package com.ytjj.qmyx.supplychain.common.model.request;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import jdk.nashorn.internal.ir.annotations.Ignore;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

/**
 * @Description TODO
 * @ClassName OrdersExpressRequest
 *
 * 
 * @Version 1.0
 **/


@Data
public class SupplyChainImportOrdersExpressRequest extends BaseRowModel {
    @ExcelProperty(index = 0,value = "收款公司")
    private String payingMerchantName;
    @ExcelProperty(index = 1,value = "订单ID")
    private String id;
    @ExcelProperty(index = 2, value = "商品ID")
    private String productId;
    @ExcelProperty(index = 3, value = "订单号")
    private String childOrderNo;
    @ExcelProperty(index = 4, value = "订单编号")
    private String orderNo;
    @ExcelProperty(index = 5,value = "订单日期")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;
    @ExcelProperty(index = 6,value = "订单来源")
    private String orderSource;
    @ExcelProperty(index = 7,value = "收货人")
    private String userName;
    @ExcelProperty(index = 8,value = "手机号")
    private String userTel;
    @ExcelProperty(index = 9,value = "收货人所在省份")
    private String province;
    @ExcelProperty(index = 10,value = "收货人所在城市")
    private String city;
    @ExcelProperty(index = 11,value = "收货人所在区县")
    private String area;
    @ExcelProperty(index = 12,value = "收货人详细地址")
    private String deliveryAddress;
    @ExcelProperty(index = 13,value = "供应商")
    private String bankerName;
    @ExcelProperty(index = 14,value = "商品名称")
    private String productName;
    @ExcelProperty(index = 15,value = "商品规格")
    private String productSkuSpec;
    @ExcelProperty(index = 16,value = "商品数量")
    private Integer productSum;
    @ExcelProperty(index = 17,value = "商品总金额（供货价+运费）")
    private String productTotalMoney;
    @ExcelProperty(index = 18,value = "商品供货价")
    private String supplyPrice;
    @ExcelProperty(index = 19,value = "商品成本")
    private String costPrice;
    @ExcelProperty(index = 20,value = "商品运费")
    private String freight;
    @ExcelProperty(index = 21,value = "订单状态")
    private String orderStatus;
    @ExcelProperty(index = 22,value = "发货状态")
    private String deliverStatus;
    @ExcelProperty(index = 23,value = "发货时间")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date importTime;
    @ExcelProperty(index = 24,value = "快递公司")
    private String expressCode;
    @ExcelProperty(index = 25,value = "快递单号")
    private String expressNo;
    @ExcelProperty(index = 26,value = "拆分快递（格式:京东物流:JD123456/顺丰速运:SF548248）")
    private String expressRecordStr;
    @ExcelProperty(index = 27,value = "是否测评商品")
    private String isZeroProduct;
    @ExcelProperty(index = 28,value = "外部SKU")
    private String threeSkuId;
    @ExcelProperty(index = 29,value = "商品款号")
    private String typeno;
    @ExcelProperty(index = 30,value = "订单备注")
    private String note;
    @ExcelProperty(index = 31,value = "客服备注")
    private String smallNote;
    @ExcelProperty(index = 32,value = "一级类目")
    private String topCategoryTitle;
    @ExcelProperty(index = 33,value = "二级类目")
    private String categoryTitle;
    @ExcelProperty(index = 34,value = "三级类目")
    private String bottomCategoryTitle;
    @ExcelProperty(index = 35,value = "身份证姓名")
    private String authenticatedName;
    @ExcelProperty(index = 36,value = "身份证号码")
    private String authenticatedCard;
    @ExcelProperty(index = 37,value = "售后状态")
    private String returnGoodStatus;
    @ExcelProperty(index = 38,value = "售后单号")
    private String serviceNo;
    @ExcelProperty(index = 39,value = "最新物流状态")
    private String latestExpressState;

}
